/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : springboot46869

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 14/05/2024 12:08:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for award_case
-- ----------------------------
DROP TABLE IF EXISTS `award_case`;
CREATE TABLE `award_case` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contest_id` bigint DEFAULT NULL,
  `contest_type_id` int DEFAULT NULL,
  `contest_price` int DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `suggestion` varchar(255) DEFAULT NULL,
  `student_id` int DEFAULT NULL COMMENT '学生id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of award_case
-- ----------------------------
BEGIN;
INSERT INTO `award_case` (`id`, `contest_id`, `contest_type_id`, `contest_price`, `file_path`, `status`, `suggestion`, `student_id`) VALUES (16, 1713687952704, 61, 2, 'http://localhost:8080/springboot46869/upload/1713966881847.JPG', 2, NULL, 1);
INSERT INTO `award_case` (`id`, `contest_id`, `contest_type_id`, `contest_price`, `file_path`, `status`, `suggestion`, `student_id`) VALUES (17, 1713687952704, 61, 2, 'http://localhost:8080/springboot46869/upload/1714013128294.JPG', 2, '恭喜', 1);
INSERT INTO `award_case` (`id`, `contest_id`, `contest_type_id`, `contest_price`, `file_path`, `status`, `suggestion`, `student_id`) VALUES (18, 1713059142987, 61, 2, NULL, 0, NULL, 1);
INSERT INTO `award_case` (`id`, `contest_id`, `contest_type_id`, `contest_price`, `file_path`, `status`, `suggestion`, `student_id`) VALUES (19, 1713687952704, 63, 2, NULL, 0, NULL, 1);
INSERT INTO `award_case` (`id`, `contest_id`, `contest_type_id`, `contest_price`, `file_path`, `status`, `suggestion`, `student_id`) VALUES (20, 1713687952704, 63, 2, 'http://localhost:8080/springboot46869/upload/1714436361660.JPG', 1, NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for baomingxinxi
-- ----------------------------
DROP TABLE IF EXISTS `baomingxinxi`;
CREATE TABLE `baomingxinxi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `jingsaishijian` varchar(200) DEFAULT NULL COMMENT '竞赛时间',
  `didian` varchar(200) DEFAULT NULL COMMENT '地点',
  `jibie` varchar(200) DEFAULT NULL COMMENT '级别',
  `xueshengzhanghao` varchar(200) DEFAULT NULL COMMENT '学生账号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710400379612 DEFAULT CHARSET=utf8mb3 COMMENT='报名信息';

-- ----------------------------
-- Records of baomingxinxi
-- ----------------------------
BEGIN;
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (111, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '竞赛时间1', '地点1', '级别1', '学生账号1', '学生姓名1', '是', '');
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (112, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '竞赛时间2', '地点2', '级别2', '学生账号2', '学生姓名2', '是', '');
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (113, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '竞赛时间3', '地点3', '级别3', '学生账号3', '学生姓名3', '是', '');
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (114, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '竞赛时间4', '地点4', '级别4', '学生账号4', '学生姓名4', '是', '');
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (115, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '竞赛时间5', '地点5', '级别5', '学生账号5', '学生姓名5', '是', '');
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (116, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '竞赛时间6', '地点6', '级别6', '学生账号6', '学生姓名6', '是', '');
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (1710400117693, '2024-03-14 15:08:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '2021-04-30', '地点1', '市级', 'abo', 'lzh1', '是', NULL);
INSERT INTO `baomingxinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `xueshengzhanghao`, `xueshengxingming`, `sfsh`, `shhf`) VALUES (1710400379611, '2024-03-14 15:12:58', '竞赛名称4', '竞赛类型4', '竞赛内容4', '2021-04-30', '地点4', '市级', 'abo', 'lzh1', '否', NULL);
COMMIT;

-- ----------------------------
-- Table structure for baoxiaoqingdan
-- ----------------------------
DROP TABLE IF EXISTS `baoxiaoqingdan`;
CREATE TABLE `baoxiaoqingdan` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` varchar(200) DEFAULT NULL COMMENT '参赛成员',
  `jingfeiyusuan` varchar(200) DEFAULT NULL COMMENT '经费预算',
  `cansaifeiyong` varchar(200) DEFAULT NULL COMMENT '参赛费用',
  `wenjian` varchar(200) DEFAULT NULL COMMENT '文件',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710651367548 DEFAULT CHARSET=utf8mb3 COMMENT='报销清单';

-- ----------------------------
-- Records of baoxiaoqingdan
-- ----------------------------
BEGIN;
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (171, '2021-04-30 16:24:36', '竞赛名称1', '队名1', '参赛成员1', '经费预算1', '参赛费用1', '', '账号1', '姓名1');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (172, '2021-04-30 16:24:36', '竞赛名称2', '队名2', '参赛成员2', '经费预算2', '参赛费用2', '', '账号2', '姓名2');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (173, '2021-04-30 16:24:36', '竞赛名称3', '队名3', '参赛成员3', '经费预算3', '参赛费用3', '', '账号3', '姓名3');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (174, '2021-04-30 16:24:36', '竞赛名称4', '队名4', '参赛成员4', '经费预算4', '参赛费用4', '', '账号4', '姓名4');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (175, '2021-04-30 16:24:36', '竞赛名称5', '队名5', '参赛成员5', '经费预算5', '参赛费用5', '', '账号5', '姓名5');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (176, '2021-04-30 16:24:36', '竞赛名称6', '队名6', '参赛成员6', '经费预算6', '参赛费用6', '', '账号6', '姓名6');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (1710651355083, '2024-03-17 12:55:55', '1', '1', '1', '1', '1', NULL, 'abo1', 'lzh2');
INSERT INTO `baoxiaoqingdan` (`id`, `addtime`, `jingsaimingcheng`, `duiming`, `cansaichengyuan`, `jingfeiyusuan`, `cansaifeiyong`, `wenjian`, `zhanghao`, `xingming`) VALUES (1710651367547, '2024-03-17 12:56:08', '1', '1', '1', '1', '1', NULL, 'abo2', 'lzh2');
COMMIT;

-- ----------------------------
-- Table structure for cansaimingdan
-- ----------------------------
DROP TABLE IF EXISTS `cansaimingdan`;
CREATE TABLE `cansaimingdan` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `jingsaishijian` varchar(200) DEFAULT NULL COMMENT '竞赛时间',
  `didian` varchar(200) DEFAULT NULL COMMENT '地点',
  `jibie` varchar(200) DEFAULT NULL COMMENT '级别',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` longtext COMMENT '参赛成员',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710401723074 DEFAULT CHARSET=utf8mb3 COMMENT='参赛名单';

-- ----------------------------
-- Records of cansaimingdan
-- ----------------------------
BEGIN;
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (131, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '竞赛时间1', '地点1', '级别1', '队名1', '参赛成员1', '账号1', '姓名1', '是', '');
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (132, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '竞赛时间2', '地点2', '级别2', '队名2', '参赛成员2', '账号2', '姓名2', '是', '');
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (133, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '竞赛时间3', '地点3', '级别3', '队名3', '参赛成员3', '账号3', '姓名3', '是', '');
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (134, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '竞赛时间4', '地点4', '级别4', '队名4', '参赛成员4', '账号4', '姓名4', '是', '');
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (135, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '竞赛时间5', '地点5', '级别5', '队名5', '参赛成员5', '账号5', '姓名5', '是', '');
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (136, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '竞赛时间6', '地点6', '级别6', '队名6', '参赛成员6', '账号6', '姓名6', '是', '');
INSERT INTO `cansaimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (1710401723073, '2024-03-14 15:35:21', '1', '1', '1', '1', '1', '1', '1', '1', 'abo', 'lzh2', '是', NULL);
COMMIT;

-- ----------------------------
-- Table structure for cansaishenqing
-- ----------------------------
DROP TABLE IF EXISTS `cansaishenqing`;
CREATE TABLE `cansaishenqing` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `jingsaishijian` varchar(200) DEFAULT NULL COMMENT '竞赛时间',
  `didian` varchar(200) DEFAULT NULL COMMENT '地点',
  `jibie` varchar(200) DEFAULT NULL COMMENT '级别',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` longtext COMMENT '参赛成员',
  `yusuan` longtext COMMENT '预算',
  `xiangmu` longtext COMMENT '项目',
  `zuopin` varchar(200) DEFAULT NULL COMMENT '作品',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710400723268 DEFAULT CHARSET=utf8mb3 COMMENT='参赛申请';

-- ----------------------------
-- Records of cansaishenqing
-- ----------------------------
BEGIN;
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (101, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '竞赛时间1', '地点1', '级别1', '队名1', '参赛成员1', '预算1', '项目1', '', '账号1', '姓名1', '是', '');
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (102, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '竞赛时间2', '地点2', '级别2', '队名2', '参赛成员2', '预算2', '项目2', '', '账号2', '姓名2', '是', '');
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (103, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '竞赛时间3', '地点3', '级别3', '队名3', '参赛成员3', '预算3', '项目3', '', '账号3', '姓名3', '是', '');
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (104, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '竞赛时间4', '地点4', '级别4', '队名4', '参赛成员4', '预算4', '项目4', '', '账号4', '姓名4', '是', '');
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (105, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '竞赛时间5', '地点5', '级别5', '队名5', '参赛成员5', '预算5', '项目5', '', '账号5', '姓名5', '是', '');
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (106, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '竞赛时间6', '地点6', '级别6', '队名6', '参赛成员6', '预算6', '项目6', '', '账号6', '姓名6', '是', '');
INSERT INTO `cansaishenqing` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `yusuan`, `xiangmu`, `zuopin`, `zhanghao`, `xingming`, `sfsh`, `shhf`) VALUES (1710400723267, '2024-03-14 15:18:41', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', NULL, 'abo', 'lzh2', '是', NULL);
COMMIT;

-- ----------------------------
-- Table structure for cansaixinxi
-- ----------------------------
DROP TABLE IF EXISTS `cansaixinxi`;
CREATE TABLE `cansaixinxi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xueshengzhanghao` varchar(200) DEFAULT NULL COMMENT '学生账号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `xuexiao` varchar(200) DEFAULT NULL COMMENT '学校',
  `zuopin` varchar(200) DEFAULT NULL COMMENT '作品',
  `zuopintese` longtext COMMENT '作品特色',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8mb3 COMMENT='参赛信息';

-- ----------------------------
-- Records of cansaixinxi
-- ----------------------------
BEGIN;
INSERT INTO `cansaixinxi` (`id`, `addtime`, `xueshengzhanghao`, `xueshengxingming`, `jingsaimingcheng`, `jingsaileixing`, `xuexiao`, `zuopin`, `zuopintese`) VALUES (191, '2021-04-30 16:24:36', '学生账号1', '学生姓名1', '竞赛名称1', '竞赛类型1', '学校1', '', '作品特色1');
INSERT INTO `cansaixinxi` (`id`, `addtime`, `xueshengzhanghao`, `xueshengxingming`, `jingsaimingcheng`, `jingsaileixing`, `xuexiao`, `zuopin`, `zuopintese`) VALUES (192, '2021-04-30 16:24:36', '学生账号2', '学生姓名2', '竞赛名称2', '竞赛类型2', '学校2', '', '作品特色2');
INSERT INTO `cansaixinxi` (`id`, `addtime`, `xueshengzhanghao`, `xueshengxingming`, `jingsaimingcheng`, `jingsaileixing`, `xuexiao`, `zuopin`, `zuopintese`) VALUES (193, '2021-04-30 16:24:36', '学生账号3', '学生姓名3', '竞赛名称3', '竞赛类型3', '学校3', '', '作品特色3');
INSERT INTO `cansaixinxi` (`id`, `addtime`, `xueshengzhanghao`, `xueshengxingming`, `jingsaimingcheng`, `jingsaileixing`, `xuexiao`, `zuopin`, `zuopintese`) VALUES (194, '2021-04-30 16:24:36', '学生账号4', '学生姓名4', '竞赛名称4', '竞赛类型4', '学校4', '', '作品特色4');
INSERT INTO `cansaixinxi` (`id`, `addtime`, `xueshengzhanghao`, `xueshengxingming`, `jingsaimingcheng`, `jingsaileixing`, `xuexiao`, `zuopin`, `zuopintese`) VALUES (195, '2021-04-30 16:24:36', '学生账号5', '学生姓名5', '竞赛名称5', '竞赛类型5', '学校5', '', '作品特色5');
INSERT INTO `cansaixinxi` (`id`, `addtime`, `xueshengzhanghao`, `xueshengxingming`, `jingsaimingcheng`, `jingsaileixing`, `xuexiao`, `zuopin`, `zuopintese`) VALUES (196, '2021-04-30 16:24:36', '学生账号6', '学生姓名6', '竞赛名称6', '竞赛类型6', '学校6', '', '作品特色6');
COMMIT;

-- ----------------------------
-- Table structure for chengjishensu
-- ----------------------------
DROP TABLE IF EXISTS `chengjishensu`;
CREATE TABLE `chengjishensu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `chengji` varchar(200) DEFAULT NULL COMMENT '成绩',
  `shensuyuanyin` varchar(200) DEFAULT NULL COMMENT '申诉原因',
  `xueshengzhanghao` varchar(200) DEFAULT NULL COMMENT '学生账号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710652173853 DEFAULT CHARSET=utf8mb3 COMMENT='成绩申诉';

-- ----------------------------
-- Records of chengjishensu
-- ----------------------------
BEGIN;
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (181, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '成绩1', '申诉原因1', '学生账号1', '学生姓名1', '账号1', '姓名1');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (182, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '成绩2', '申诉原因2', '学生账号2', '学生姓名2', '账号2', '姓名2');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (183, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '成绩3', '申诉原因3', '学生账号3', '学生姓名3', '账号3', '姓名3');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (184, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '成绩4', '申诉原因4', '学生账号4', '学生姓名4', '账号4', '姓名4');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (185, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '成绩5', '申诉原因5', '学生账号5', '学生姓名5', '账号5', '姓名5');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (186, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '成绩6', '申诉原因6', '学生账号6', '学生姓名6', '账号6', '姓名6');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (1710651977736, '2024-03-17 13:06:17', NULL, NULL, NULL, NULL, 'abo1', 'lzh1', NULL, NULL);
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (1710651992004, '2024-03-17 13:06:32', '1', '1', '1', '111', 'abo1', 'lzh1', '1', '1');
INSERT INTO `chengjishensu` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `chengji`, `shensuyuanyin`, `xueshengzhanghao`, `xueshengxingming`, `zhanghao`, `xingming`) VALUES (1710652173852, '2024-03-17 13:09:33', NULL, NULL, NULL, NULL, 'abo', 'lzh1', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COMMENT='配置文件';

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` (`id`, `name`, `value`) VALUES (1, 'picture1', 'http://localhost:8080/springboot46869/upload/picture1.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (2, 'picture2', 'http://localhost:8080/springboot46869/upload/picture2.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (3, 'picture3', 'http://localhost:8080/springboot46869/upload/picture3.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (6, 'homepage', NULL);
COMMIT;

-- ----------------------------
-- Table structure for contest_credits
-- ----------------------------
DROP TABLE IF EXISTS `contest_credits`;
CREATE TABLE `contest_credits` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contest_type_id` int DEFAULT NULL,
  `contest_price` int DEFAULT NULL,
  `credits` float DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of contest_credits
-- ----------------------------
BEGIN;
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (4, 61, 1, 2, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (10, 61, 2, 1.5, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (11, 61, 3, 1, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (12, 62, 1, 1.5, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (13, 62, 2, 1, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (14, 62, 3, 0.5, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (15, 63, 1, 1, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (16, 63, 2, 0.75, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (17, 63, 3, 0.5, NULL);
INSERT INTO `contest_credits` (`id`, `contest_type_id`, `contest_price`, `credits`, `memo`) VALUES (18, 63, 1, 2, NULL);
COMMIT;

-- ----------------------------
-- Table structure for huojiangmingdan
-- ----------------------------
DROP TABLE IF EXISTS `huojiangmingdan`;
CREATE TABLE `huojiangmingdan` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `jingsaishijian` varchar(200) DEFAULT NULL COMMENT '竞赛时间',
  `didian` varchar(200) DEFAULT NULL COMMENT '地点',
  `jibie` varchar(200) DEFAULT NULL COMMENT '级别',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` longtext COMMENT '参赛成员',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710649754133 DEFAULT CHARSET=utf8mb3 COMMENT='获奖名单';

-- ----------------------------
-- Records of huojiangmingdan
-- ----------------------------
BEGIN;
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (151, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '竞赛时间1', '地点1', '级别1', '队名1', '参赛成员1', '账号1', '姓名1');
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (152, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '竞赛时间2', '地点2', '级别2', '队名2', '参赛成员2', '账号2', '姓名2');
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (153, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '竞赛时间3', '地点3', '级别3', '队名3', '参赛成员3', '账号3', '姓名3');
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (154, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '竞赛时间4', '地点4', '级别4', '队名4', '参赛成员4', '账号4', '姓名4');
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (155, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '竞赛时间5', '地点5', '级别5', '队名5', '参赛成员5', '账号5', '姓名5');
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (156, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '竞赛时间6', '地点6', '级别6', '队名6', '参赛成员6', '账号6', '姓名6');
INSERT INTO `huojiangmingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (1710649754132, '2024-03-17 12:29:05', '1', '1', '1', '1', '1', '1', '1', '1', 'abo', 'lzh');
COMMIT;

-- ----------------------------
-- Table structure for huojiangqingkuang
-- ----------------------------
DROP TABLE IF EXISTS `huojiangqingkuang`;
CREATE TABLE `huojiangqingkuang` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` longtext COMMENT '参赛成员',
  `renshu` varchar(200) DEFAULT NULL COMMENT '人数',
  `huojiangjine` int DEFAULT NULL COMMENT '获奖金额',
  `huojiangmingxi` longtext COMMENT '获奖明细',
  `beizhu` longtext COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1713067579563 DEFAULT CHARSET=utf8mb3 COMMENT='获奖情况';

-- ----------------------------
-- Records of huojiangqingkuang
-- ----------------------------
BEGIN;
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (211, '2021-04-30 16:24:36', '队名1', '参赛成员1', '人数1', 1, '获奖明细1', '备注1');
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (212, '2021-04-30 16:24:36', '队名2', '参赛成员2', '人数2', 2, '获奖明细2', '备注2');
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (213, '2021-04-30 16:24:36', '队名3', '参赛成员3', '人数3', 3, '获奖明细3', '备注3');
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (214, '2021-04-30 16:24:36', '队名4', '参赛成员4', '人数4', 4, '获奖明细4', '备注4');
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (215, '2021-04-30 16:24:36', '队名5', '参赛成员5', '人数5', 5, '获奖明细5', '备注5');
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (216, '2021-04-30 16:24:36', '队名6', '参赛成员6', '人数6', 6, '获奖明细6', '备注6');
INSERT INTO `huojiangqingkuang` (`id`, `addtime`, `duiming`, `cansaichengyuan`, `renshu`, `huojiangjine`, `huojiangmingxi`, `beizhu`) VALUES (1713067579562, '2024-04-14 12:06:19', NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for jiaoshi
-- ----------------------------
DROP TABLE IF EXISTS `jiaoshi`;
CREATE TABLE `jiaoshi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhanghao` varchar(200) NOT NULL COMMENT '账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1710340668905 DEFAULT CHARSET=utf8mb3 COMMENT='教师';

-- ----------------------------
-- Records of jiaoshi
-- ----------------------------
BEGIN;
INSERT INTO `jiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `shouji`, `youxiang`, `touxiang`) VALUES (1710340668904, '2024-03-13 22:37:49', 'abo', 'abo', 'lzh', '男', '13897789590', 'qweoifj@qq.com', NULL);
COMMIT;

-- ----------------------------
-- Table structure for jingsaileixing
-- ----------------------------
DROP TABLE IF EXISTS `jingsaileixing`;
CREATE TABLE `jingsaileixing` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jianjie` longtext COMMENT '简介',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1713099016725 DEFAULT CHARSET=utf8mb3 COMMENT='竞赛类型';

-- ----------------------------
-- Records of jingsaileixing
-- ----------------------------
BEGIN;
INSERT INTO `jingsaileixing` (`id`, `addtime`, `jingsaileixing`, `jianjie`) VALUES (61, '2021-04-30 16:24:36', 'A类', '难度较大，奖项对应哈尔滨理工大学A类竞赛');
INSERT INTO `jingsaileixing` (`id`, `addtime`, `jingsaileixing`, `jianjie`) VALUES (62, '2021-04-30 16:24:36', 'B类', '对应哈尔滨理工大学B类奖项');
INSERT INTO `jingsaileixing` (`id`, `addtime`, `jingsaileixing`, `jianjie`) VALUES (63, '2021-04-30 16:24:36', 'C类', '对应哈尔滨理工大学C类奖项');
COMMIT;

-- ----------------------------
-- Table structure for jingsaipingfen
-- ----------------------------
DROP TABLE IF EXISTS `jingsaipingfen`;
CREATE TABLE `jingsaipingfen` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` varchar(200) DEFAULT NULL COMMENT '参赛成员',
  `zuopinpingfen` varchar(200) DEFAULT NULL COMMENT '作品评分',
  `pingjianeirong` longtext COMMENT '评价内容',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `xueshengzhanghao` varchar(200) DEFAULT NULL COMMENT '学生账号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb3 COMMENT='竞赛评分';

-- ----------------------------
-- Records of jingsaipingfen
-- ----------------------------
BEGIN;
INSERT INTO `jingsaipingfen` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `zuopinpingfen`, `pingjianeirong`, `zhanghao`, `xingming`, `xueshengzhanghao`, `xueshengxingming`) VALUES (121, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '队名1', '参赛成员1', '作品评分1', '评价内容1', '账号1', '姓名1', '学生账号1', '学生姓名1');
INSERT INTO `jingsaipingfen` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `zuopinpingfen`, `pingjianeirong`, `zhanghao`, `xingming`, `xueshengzhanghao`, `xueshengxingming`) VALUES (122, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '队名2', '参赛成员2', '作品评分2', '评价内容2', '账号2', '姓名2', '学生账号2', '学生姓名2');
INSERT INTO `jingsaipingfen` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `zuopinpingfen`, `pingjianeirong`, `zhanghao`, `xingming`, `xueshengzhanghao`, `xueshengxingming`) VALUES (123, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '队名3', '参赛成员3', '作品评分3', '评价内容3', '账号3', '姓名3', '学生账号3', '学生姓名3');
INSERT INTO `jingsaipingfen` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `zuopinpingfen`, `pingjianeirong`, `zhanghao`, `xingming`, `xueshengzhanghao`, `xueshengxingming`) VALUES (124, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '队名4', '参赛成员4', '作品评分4', '评价内容4', '账号4', '姓名4', '学生账号4', '学生姓名4');
INSERT INTO `jingsaipingfen` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `zuopinpingfen`, `pingjianeirong`, `zhanghao`, `xingming`, `xueshengzhanghao`, `xueshengxingming`) VALUES (125, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '队名5', '参赛成员5', '作品评分5', '评价内容5', '账号5', '姓名5', '学生账号5', '学生姓名5');
INSERT INTO `jingsaipingfen` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `zuopinpingfen`, `pingjianeirong`, `zhanghao`, `xingming`, `xueshengzhanghao`, `xueshengxingming`) VALUES (126, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '队名6', '参赛成员6', '作品评分6', '评价内容6', '账号6', '姓名6', '学生账号6', '学生姓名6');
COMMIT;

-- ----------------------------
-- Table structure for jingsaitiku
-- ----------------------------
DROP TABLE IF EXISTS `jingsaitiku`;
CREATE TABLE `jingsaitiku` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `daan` longtext COMMENT '答案',
  `timu` longtext COMMENT '题目',
  `timuleixing` varchar(200) DEFAULT NULL COMMENT '题目类型',
  `wenjian` varchar(200) DEFAULT NULL COMMENT '文件',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb3 COMMENT='竞赛题库';

-- ----------------------------
-- Records of jingsaitiku
-- ----------------------------
BEGIN;
INSERT INTO `jingsaitiku` (`id`, `addtime`, `daan`, `timu`, `timuleixing`, `wenjian`) VALUES (51, '2021-04-30 16:24:36', '答案1', '题目1', '题目类型1', '');
INSERT INTO `jingsaitiku` (`id`, `addtime`, `daan`, `timu`, `timuleixing`, `wenjian`) VALUES (52, '2021-04-30 16:24:36', '答案2', '题目2', '题目类型2', '');
INSERT INTO `jingsaitiku` (`id`, `addtime`, `daan`, `timu`, `timuleixing`, `wenjian`) VALUES (53, '2021-04-30 16:24:36', '答案3', '题目3', '题目类型3', '');
INSERT INTO `jingsaitiku` (`id`, `addtime`, `daan`, `timu`, `timuleixing`, `wenjian`) VALUES (54, '2021-04-30 16:24:36', '答案4', '题目4', '题目类型4', '');
INSERT INTO `jingsaitiku` (`id`, `addtime`, `daan`, `timu`, `timuleixing`, `wenjian`) VALUES (55, '2021-04-30 16:24:36', '答案5', '题目5', '题目类型5', '');
INSERT INTO `jingsaitiku` (`id`, `addtime`, `daan`, `timu`, `timuleixing`, `wenjian`) VALUES (56, '2021-04-30 16:24:36', '答案6', '题目6', '题目类型6', '');
COMMIT;

-- ----------------------------
-- Table structure for jingsaixinxi
-- ----------------------------
DROP TABLE IF EXISTS `jingsaixinxi`;
CREATE TABLE `jingsaixinxi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaimude` longtext COMMENT '竞赛目的',
  `jingsaineirong` longtext COMMENT '竞赛内容',
  `jingsaishijian` date DEFAULT NULL COMMENT '竞赛时间',
  `didian` longtext COMMENT '地点',
  `jibie` varchar(200) DEFAULT NULL COMMENT '级别',
  `jubandanwei` varchar(200) DEFAULT NULL COMMENT '举办单位',
  `chengbandanwei` varchar(200) DEFAULT NULL COMMENT '承办单位',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1713687952705 DEFAULT CHARSET=utf8mb3 COMMENT='竞赛信息';

-- ----------------------------
-- Records of jingsaixinxi
-- ----------------------------
BEGIN;
INSERT INTO `jingsaixinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaimude`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `jubandanwei`, `chengbandanwei`, `tupian`) VALUES (71, '2021-04-30 16:24:36', '[省赛] 蓝桥杯', 'B类', '为贯彻落实《中国教育现代化 2035》和《国务院关于印发新时期促进集成电路产业和软件产业高质量发展若干政策的通知》有关精神，为我国制造强国和网络强国战略提供人才支持，提高学生自主创新意识和工程实践能力，中心特举办第十五届蓝桥杯全国软件和信息 技术专业人才大赛。', '1.Java 软件开发\n2.C/C++ 软件开发\n3.Python 程序设计\n\n官网报名：https://dasai.lanqiao.cn/', '2023-04-13', '哈尔滨理工大学新主楼', '省级', '教育部', '教育部', 'http://localhost:8080/springboot46869/upload/jingsaixinxi_tupian1.jpg');
INSERT INTO `jingsaixinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaimude`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `jubandanwei`, `chengbandanwei`, `tupian`) VALUES (1713059142987, '2024-04-14 09:45:42', '[国赛] 数学建模', 'A类', '提升编程能力', '数据结构与算法', '2024-05-24', '哈尔滨理工大学', '国家级', '教育部', '教育部', 'http://localhost:8080/springboot46869/upload/1714035169719.JPG');
INSERT INTO `jingsaixinxi` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaimude`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `jubandanwei`, `chengbandanwei`, `tupian`) VALUES (1713687952704, '2024-04-21 16:25:51', '[国赛] 小马争夺赛', 'C类', '争夺小马', '争夺小马', '2024-05-24', '哈尔滨理工大学', '国家级', '哈尔滨理工大学', '哈尔滨理工大学', 'http://localhost:8080/springboot46869/upload/1713687933587.JPG');
COMMIT;

-- ----------------------------
-- Table structure for jingsaizongjie
-- ----------------------------
DROP TABLE IF EXISTS `jingsaizongjie`;
CREATE TABLE `jingsaizongjie` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` varchar(200) DEFAULT NULL COMMENT '参赛成员',
  `jingsaizongjie` varchar(200) DEFAULT NULL COMMENT '竞赛总结',
  `wenjian` varchar(200) DEFAULT NULL COMMENT '文件',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710650002172 DEFAULT CHARSET=utf8mb3 COMMENT='竞赛总结';

-- ----------------------------
-- Records of jingsaizongjie
-- ----------------------------
BEGIN;
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (161, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '队名1', '参赛成员1', '竞赛总结1', '', '账号1', '姓名1');
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (162, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '队名2', '参赛成员2', '竞赛总结2', '', '账号2', '姓名2');
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (163, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '队名3', '参赛成员3', '竞赛总结3', '', '账号3', '姓名3');
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (164, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '队名4', '参赛成员4', '竞赛总结4', '', '账号4', '姓名4');
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (165, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '队名5', '参赛成员5', '竞赛总结5', '', '账号5', '姓名5');
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (166, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '队名6', '参赛成员6', '竞赛总结6', '', '账号6', '姓名6');
INSERT INTO `jingsaizongjie` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `duiming`, `cansaichengyuan`, `jingsaizongjie`, `wenjian`, `zhanghao`, `xingming`) VALUES (1710650002171, '2024-03-17 12:33:22', '去', '去', '去', '去', '去', '去', NULL, 'abo', 'lzh2');
COMMIT;

-- ----------------------------
-- Table structure for jinjimingdan
-- ----------------------------
DROP TABLE IF EXISTS `jinjimingdan`;
CREATE TABLE `jinjimingdan` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `jingsaineirong` varchar(200) DEFAULT NULL COMMENT '竞赛内容',
  `jingsaishijian` varchar(200) DEFAULT NULL COMMENT '竞赛时间',
  `didian` varchar(200) DEFAULT NULL COMMENT '地点',
  `jibie` varchar(200) DEFAULT NULL COMMENT '级别',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` longtext COMMENT '参赛成员',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710649741737 DEFAULT CHARSET=utf8mb3 COMMENT='晋级名单';

-- ----------------------------
-- Records of jinjimingdan
-- ----------------------------
BEGIN;
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (141, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '竞赛内容1', '竞赛时间1', '地点1', '级别1', '队名1', '参赛成员1', '账号1', '姓名1');
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (142, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '竞赛内容2', '竞赛时间2', '地点2', '级别2', '队名2', '参赛成员2', '账号2', '姓名2');
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (143, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '竞赛内容3', '竞赛时间3', '地点3', '级别3', '队名3', '参赛成员3', '账号3', '姓名3');
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (144, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '竞赛内容4', '竞赛时间4', '地点4', '级别4', '队名4', '参赛成员4', '账号4', '姓名4');
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (145, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '竞赛内容5', '竞赛时间5', '地点5', '级别5', '队名5', '参赛成员5', '账号5', '姓名5');
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (146, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '竞赛内容6', '竞赛时间6', '地点6', '级别6', '队名6', '参赛成员6', '账号6', '姓名6');
INSERT INTO `jinjimingdan` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `jingsaineirong`, `jingsaishijian`, `didian`, `jibie`, `duiming`, `cansaichengyuan`, `zhanghao`, `xingming`) VALUES (1710649741736, '2024-03-17 12:28:52', '1', '1', '1', '1', '1', '1', '1', '1', 'abo', 'lzh');
COMMIT;

-- ----------------------------
-- Table structure for lingduijiaoshi
-- ----------------------------
DROP TABLE IF EXISTS `lingduijiaoshi`;
CREATE TABLE `lingduijiaoshi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhanghao` varchar(200) NOT NULL COMMENT '账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `jiaogonghao` varchar(200) DEFAULT NULL COMMENT '教工号',
  `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院',
  `zhuanyelingyu` longtext COMMENT '专业领域',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1710340955290 DEFAULT CHARSET=utf8mb3 COMMENT='领队教师';

-- ----------------------------
-- Records of lingduijiaoshi
-- ----------------------------
BEGIN;
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (31, '2021-04-30 16:24:36', '领队教师1', '123456', '姓名1', '男', '教工号1', '学院1', '专业领域1', '13823888881', '773890001@qq.com', 'http://localhost:8080/springboot46869/upload/lingduijiaoshi_touxiang1.jpg');
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (32, '2021-04-30 16:24:36', '领队教师2', '123456', '姓名2', '男', '教工号2', '学院2', '专业领域2', '13823888882', '773890002@qq.com', 'http://localhost:8080/springboot46869/upload/lingduijiaoshi_touxiang2.jpg');
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (33, '2021-04-30 16:24:36', '领队教师3', '123456', '姓名3', '男', '教工号3', '学院3', '专业领域3', '13823888883', '773890003@qq.com', 'http://localhost:8080/springboot46869/upload/lingduijiaoshi_touxiang3.jpg');
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (34, '2021-04-30 16:24:36', '领队教师4', '123456', '姓名4', '男', '教工号4', '学院4', '专业领域4', '13823888884', '773890004@qq.com', 'http://localhost:8080/springboot46869/upload/lingduijiaoshi_touxiang4.jpg');
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (35, '2021-04-30 16:24:36', '领队教师5', '123456', '姓名5', '男', '教工号5', '学院5', '专业领域5', '13823888885', '773890005@qq.com', 'http://localhost:8080/springboot46869/upload/lingduijiaoshi_touxiang5.jpg');
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (36, '2021-04-30 16:24:36', '领队教师6', '123456', '姓名6', '男', '教工号6', '学院6', '专业领域6', '13823888886', '773890006@qq.com', 'http://localhost:8080/springboot46869/upload/lingduijiaoshi_touxiang6.jpg');
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (1710337184265, '2024-03-13 21:39:44', '123', '123', '123', NULL, '123', NULL, NULL, '13483499863', '1275796284@qq.com', NULL);
INSERT INTO `lingduijiaoshi` (`id`, `addtime`, `zhanghao`, `mima`, `xingming`, `xingbie`, `jiaogonghao`, `xueyuan`, `zhuanyelingyu`, `shouji`, `youxiang`, `touxiang`) VALUES (1710340955289, '2024-03-13 22:42:35', 'abo', 'abo', 'lzh2', NULL, '3024762175', NULL, NULL, '12345678901', '2@qq.com', 'http://localhost:8080/springboot46869/upload/1710742584969.JPG');
COMMIT;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `introduction` longtext COMMENT '简介',
  `picture` varchar(200) NOT NULL COMMENT '图片',
  `content` longtext NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=utf8mb3 COMMENT='竞赛资讯';

-- ----------------------------
-- Records of news
-- ----------------------------
BEGIN;
INSERT INTO `news` (`id`, `addtime`, `title`, `introduction`, `picture`, `content`) VALUES (221, '2021-04-30 16:24:36', '标题1', '简介1', 'http://localhost:8080/springboot46869/upload/news_picture1.jpg', '内容1');
INSERT INTO `news` (`id`, `addtime`, `title`, `introduction`, `picture`, `content`) VALUES (222, '2021-04-30 16:24:36', '标题2', '简介2', 'http://localhost:8080/springboot46869/upload/news_picture2.jpg', '内容2');
INSERT INTO `news` (`id`, `addtime`, `title`, `introduction`, `picture`, `content`) VALUES (223, '2021-04-30 16:24:36', '标题3', '简介3', 'http://localhost:8080/springboot46869/upload/news_picture3.jpg', '内容3');
INSERT INTO `news` (`id`, `addtime`, `title`, `introduction`, `picture`, `content`) VALUES (224, '2021-04-30 16:24:36', '标题4', '简介4', 'http://localhost:8080/springboot46869/upload/news_picture4.jpg', '内容4');
INSERT INTO `news` (`id`, `addtime`, `title`, `introduction`, `picture`, `content`) VALUES (225, '2021-04-30 16:24:36', '标题5', '简介5', 'http://localhost:8080/springboot46869/upload/news_picture5.jpg', '内容5');
INSERT INTO `news` (`id`, `addtime`, `title`, `introduction`, `picture`, `content`) VALUES (226, '2021-04-30 16:24:36', '标题6', '简介6', 'http://localhost:8080/springboot46869/upload/news_picture6.jpg', '内容6');
COMMIT;

-- ----------------------------
-- Table structure for r_price_mapping
-- ----------------------------
DROP TABLE IF EXISTS `r_price_mapping`;
CREATE TABLE `r_price_mapping` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contest_id` bigint DEFAULT NULL,
  `contest_price_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contest_credits_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of r_price_mapping
-- ----------------------------
BEGIN;
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (1, 1713687952704, 'A奖', 4);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (2, 1713687952704, NULL, NULL);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (3, 1713687952704, NULL, NULL);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (4, NULL, NULL, NULL);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (6, 1713687952704, '真爱奖', 4);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (7, NULL, '', NULL);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (8, 1713687952704, '', NULL);
INSERT INTO `r_price_mapping` (`id`, `contest_id`, `contest_price_name`, `contest_credits_id`) VALUES (11, 1713687952704, 'ss', NULL);
COMMIT;

-- ----------------------------
-- Table structure for r_teacher_contest
-- ----------------------------
DROP TABLE IF EXISTS `r_teacher_contest`;
CREATE TABLE `r_teacher_contest` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contest_id` bigint DEFAULT NULL,
  `teacher_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of r_teacher_contest
-- ----------------------------
BEGIN;
INSERT INTO `r_teacher_contest` (`id`, `contest_id`, `teacher_id`) VALUES (1, 1713687952704, 1710340668904);
COMMIT;

-- ----------------------------
-- Table structure for timuleixing
-- ----------------------------
DROP TABLE IF EXISTS `timuleixing`;
CREATE TABLE `timuleixing` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `timuleixing` varchar(200) DEFAULT NULL COMMENT '题目类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COMMENT='题目类型';

-- ----------------------------
-- Records of timuleixing
-- ----------------------------
BEGIN;
INSERT INTO `timuleixing` (`id`, `addtime`, `timuleixing`) VALUES (41, '2021-04-30 16:24:36', '题目类型1');
INSERT INTO `timuleixing` (`id`, `addtime`, `timuleixing`) VALUES (42, '2021-04-30 16:24:36', '题目类型2');
INSERT INTO `timuleixing` (`id`, `addtime`, `timuleixing`) VALUES (43, '2021-04-30 16:24:36', '题目类型3');
INSERT INTO `timuleixing` (`id`, `addtime`, `timuleixing`) VALUES (44, '2021-04-30 16:24:36', '题目类型4');
INSERT INTO `timuleixing` (`id`, `addtime`, `timuleixing`) VALUES (45, '2021-04-30 16:24:36', '题目类型5');
INSERT INTO `timuleixing` (`id`, `addtime`, `timuleixing`) VALUES (46, '2021-04-30 16:24:36', '题目类型6');
COMMIT;

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COMMENT='token表';

-- ----------------------------
-- Records of token
-- ----------------------------
BEGIN;
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (1, 1, 'abo', 'users', '管理员', 'vbgw6ucg836xj652k4aria976evmb67h', '2024-03-13 20:40:41', '2024-04-30 10:07:53');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (2, 1710337184265, '123', 'lingduijiaoshi', '领队教师', 'e8kicxdvdnrcjxyb17l977sdyjzy8bqj', '2024-03-13 21:39:51', '2024-03-13 22:39:52');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (3, 1710340668904, 'abo', 'jiaoshi', '教师', '5guubvqs6vh1k5p4ep80tkyiw2b04yyg', '2024-03-13 22:37:53', '2024-04-30 09:19:29');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (4, 1710340803209, 'abo', 'xuesheng', '学生', '2bw2vl7t8eo8bpyan9rc0fdrreh8gd0l', '2024-03-13 22:40:09', '2024-03-18 17:14:27');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (5, 1710340955289, 'abo', 'lingduijiaoshi', '领队教师', 'j8d7l8g0egz25a8xj0rj2sjjtdx5rcm4', '2024-03-13 22:42:41', '2024-03-18 15:56:11');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (6, 1712648676316, 'liang', 'xuesheng', '学生', 'bdhydiy3wcn3p72ftzewdo93k9rr732w', '2024-04-10 20:08:12', '2024-04-10 21:08:12');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (7, 1, 'liang', 'xuesheng', '学生', 'j76azajrlm879y8wqfjhoipn9zo5yi93', '2024-04-12 20:38:56', '2024-04-30 10:03:12');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `role`, `addtime`) VALUES (1, 'abo', 'abo', '管理员', '2021-04-30 16:24:36');
COMMIT;

-- ----------------------------
-- Table structure for wangnianchengji
-- ----------------------------
DROP TABLE IF EXISTS `wangnianchengji`;
CREATE TABLE `wangnianchengji` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingsaimingcheng` varchar(200) DEFAULT NULL COMMENT '竞赛名称',
  `jingsaileixing` varchar(200) DEFAULT NULL COMMENT '竞赛类型',
  `riqi` date DEFAULT NULL COMMENT '日期',
  `chengji` int DEFAULT NULL COMMENT '成绩',
  `duiming` varchar(200) DEFAULT NULL COMMENT '队名',
  `cansaichengyuan` longtext COMMENT '参赛成员',
  `lingduijiaoshi` varchar(200) DEFAULT NULL COMMENT '领队教师',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb3 COMMENT='往年成绩';

-- ----------------------------
-- Records of wangnianchengji
-- ----------------------------
BEGIN;
INSERT INTO `wangnianchengji` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `riqi`, `chengji`, `duiming`, `cansaichengyuan`, `lingduijiaoshi`) VALUES (201, '2021-04-30 16:24:36', '竞赛名称1', '竞赛类型1', '2021-04-30', 1, '队名1', '参赛成员1', '领队教师1');
INSERT INTO `wangnianchengji` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `riqi`, `chengji`, `duiming`, `cansaichengyuan`, `lingduijiaoshi`) VALUES (202, '2021-04-30 16:24:36', '竞赛名称2', '竞赛类型2', '2021-04-30', 2, '队名2', '参赛成员2', '领队教师2');
INSERT INTO `wangnianchengji` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `riqi`, `chengji`, `duiming`, `cansaichengyuan`, `lingduijiaoshi`) VALUES (203, '2021-04-30 16:24:36', '竞赛名称3', '竞赛类型3', '2021-04-30', 3, '队名3', '参赛成员3', '领队教师3');
INSERT INTO `wangnianchengji` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `riqi`, `chengji`, `duiming`, `cansaichengyuan`, `lingduijiaoshi`) VALUES (204, '2021-04-30 16:24:36', '竞赛名称4', '竞赛类型4', '2021-04-30', 4, '队名4', '参赛成员4', '领队教师4');
INSERT INTO `wangnianchengji` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `riqi`, `chengji`, `duiming`, `cansaichengyuan`, `lingduijiaoshi`) VALUES (205, '2021-04-30 16:24:36', '竞赛名称5', '竞赛类型5', '2021-04-30', 5, '队名5', '参赛成员5', '领队教师5');
INSERT INTO `wangnianchengji` (`id`, `addtime`, `jingsaimingcheng`, `jingsaileixing`, `riqi`, `chengji`, `duiming`, `cansaichengyuan`, `lingduijiaoshi`) VALUES (206, '2021-04-30 16:24:36', '竞赛名称6', '竞赛类型6', '2021-04-30', 6, '队名6', '参赛成员6', '领队教师6');
COMMIT;

-- ----------------------------
-- Table structure for xuesheng
-- ----------------------------
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xueshengzhanghao` varchar(200) NOT NULL COMMENT '学生账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `nianji` varchar(200) DEFAULT NULL COMMENT '年级',
  `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院',
  `canyujingsai` varchar(200) DEFAULT NULL COMMENT '参与竞赛',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `xueshengzhanghao` (`xueshengzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1712648676317 DEFAULT CHARSET=utf8mb3 COMMENT='学生';

-- ----------------------------
-- Records of xuesheng
-- ----------------------------
BEGIN;
INSERT INTO `xuesheng` (`id`, `addtime`, `xueshengzhanghao`, `mima`, `xueshengxingming`, `xingbie`, `xuehao`, `nianji`, `xueyuan`, `canyujingsai`, `shouji`, `youxiang`, `touxiang`) VALUES (1, '2024-04-09 15:44:36', 'liang', 'liang', '马国良', '男', '2320400058', '软件工程学硕研23', '计算机科学与技术学院', '是', '18830543657', '772399887@qq.com', 'http://localhost:8080/springboot46869/upload/1712648674446.JPG');
COMMIT;

-- ----------------------------
-- Table structure for xueyuan
-- ----------------------------
DROP TABLE IF EXISTS `xueyuan`;
CREATE TABLE `xueyuan` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院',
  `xueyuanjianjie` longtext COMMENT '学院简介',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1712648833665 DEFAULT CHARSET=utf8mb3 COMMENT='学院';

-- ----------------------------
-- Records of xueyuan
-- ----------------------------
BEGIN;
INSERT INTO `xueyuan` (`id`, `addtime`, `xueyuan`, `xueyuanjianjie`, `tupian`) VALUES (1712648833664, '2024-04-09 15:47:13', '软件学院', '计算机贼好', 'http://localhost:8080/springboot46869/upload/1714438704044.JPG');
COMMIT;

-- ----------------------------
-- Table structure for zhuanye
-- ----------------------------
DROP TABLE IF EXISTS `zhuanye`;
CREATE TABLE `zhuanye` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `zhuanyejianjie` longtext COMMENT '专业简介',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710333907402 DEFAULT CHARSET=utf8mb3 COMMENT='专业';

-- ----------------------------
-- Records of zhuanye
-- ----------------------------
BEGIN;
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (91, '2021-04-30 16:24:36', '学院1', '专业1', '专业简介1', 'http://localhost:8080/springboot46869/upload/zhuanye_tupian1.jpg');
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (92, '2021-04-30 16:24:36', '学院2', '专业2', '专业简介2', 'http://localhost:8080/springboot46869/upload/zhuanye_tupian2.jpg');
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (93, '2021-04-30 16:24:36', '学院3', '专业3', '专业简介3', 'http://localhost:8080/springboot46869/upload/zhuanye_tupian3.jpg');
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (94, '2021-04-30 16:24:36', '学院4', '专业4', '专业简介4', 'http://localhost:8080/springboot46869/upload/zhuanye_tupian4.jpg');
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (95, '2021-04-30 16:24:36', '学院5', '专业5', '专业简介5', 'http://localhost:8080/springboot46869/upload/zhuanye_tupian5.jpg');
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (96, '2021-04-30 16:24:36', '学院6', '专业6', '专业简介6', 'http://localhost:8080/springboot46869/upload/zhuanye_tupian6.jpg');
INSERT INTO `zhuanye` (`id`, `addtime`, `xueyuan`, `zhuanye`, `zhuanyejianjie`, `tupian`) VALUES (1710333907401, '2024-03-13 20:45:06', '小马学院', '软件', '22', 'http://localhost:8080/springboot46869/upload/1710333869127.JPG');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
